Senior Database Administrator | AppNexus Inc. | New York, United States
Senior Database Administrator (New York)Technical Operations | New York, United States |
Team Description:
The Technical Operations team is distributed across the globe and handles a wide variety of responsibilities, from providing tech support to architecting long-range build-out and day-to-day operations at our six global data centers. We have well over 7,000 servers, which process over a million of ad serving requests per second (billions per day). We are an all Linux shop (all production operations run on Linux), with mostly Mac laptops.We’re in search of troubleshooters and those who love to tinker and innovate with technology.
Role description:
The Senior Database Administrator is responsible for participating in building, operating, and maintaining a heterogeneous datastore environment in the Technical Operations group. The data environment consists primarily of Hadoop, MySQL, PostgreSQL, Vertica and Citrusleaf’s clustered low latency key-value data store and is constantly growing.
Responsibilities:
- Help keep the database and data systems infrastructure running smoothly
- Work with Data Engineering team to help design and implement next iteration of scaling (and the next, and the next, ...)
- Tune and optimize systems, processes, queries, databases to handle constantly increasing data flows
- Participate in prototyping and proof of concept system development and benchmarking
- Install patches and do upgrades as required
- Write and perform DML and DDL as required
- Manage storage restructuring as required
- Participate in on-call rotation responding to alerts and systems issues
- Audit various databases to ensure data integrity
- Deal with the usual database situations (replication, stale locks, queries run amok, tables that need to be indexed but are not, managing constraints)
At least one of the following two, with a strong desire and capability to learn and gain expertise in both:
1. Extensive DBA experience with a majority of the following:
- MySQL
- PostgreSQL
- Columnar databases (Vertica)
- Key-value Store/NoSQL
- HDFS
- HBase
- Hive, Pig, Sqoop
- 2+ years of hands on Unix/Linux system administration
- Proficiency with cron, syslog, and other Unix system interfaces/utilities
- Excellent troubleshooting skills
- Excellent written and oral communication skills
- Good organizational skills
- High professional standards and desire to continue to develops skills and growth professionally
- Strong commitment and drive to deliver high quality service to all customers, regardless of whether they are internal or external
- Experience with Network Attached Storage (NAS)
- Experience with system administration automation software such as Chef, cfengine, or Puppet (Puppet preferred)
- Perl and/or Python programming experience
- Regular expression fluency
- Substantial experience with networking from a systems standpoint to include but not limited to TCP/IP, DNS, DHCP, SNMP, ARP, NTP, SMTP, HTTP
- Experience with Nagios or similar monitoring tools
- Experience with data collection/graphing tools like Cacti, Ganglia, and Graphite
- Experience using a Mac
- Experience with tcpdump, ethereal, and other packet capture and analysis tools
- Bachelor Degree in CS or MIS, or equivalent experience desirable
- You want to be part of an organization with a transparent and agile environment where you can communicate freely and openly.
- You look for novel and creative solutions to complex problems.
- You are an independent thinker who is self-motivated and thrives in a fast-paced work environment.
- You are passionate about and thrive in a culture of learning and teaching – you are both open minded to others’ opinions and take opportunities to help and teach colleagues.
What's in it for you:
- Industry-changing work – build bold solutions to some of today’s most exciting technical challenges.
- Significant impact from your very first day thanks to our rapidly growing scale and agile engineering teams.
- Competitive benefits package, with plan options to design the coverage to fit your life — highly subsidized health, dental and vision insurance coverage from day one, fully vested employer-matched 401(k), company-seeded health savings accounts, back-up childcare, pet insurance, and much more.
- Global presence – AppNexus has offices around the world: Manhattan, San Francisco, Seattle, Portland, London, Paris, Hamburg, Toronto, Sydney, and Singapore. Engineers are primarily based in Manhattan and Portland.
- Regular access to industry events - AppNexus hosts many technical meet-ups and speakers on site.
- We are a technology company at heart. Our founders can hold their own in architecture discussions with the team. Occasionally, our CEO even checks-in bug fixes to the ad server codebase.
The other perks:
- Great Technology: Any computer of your choosing. Most of our team develop using retina displayed MacBook Pros, with multiple monitors for additional screen real estate.
- Free Food: Every office has fully-stocked kitchens featuring bagels each morning, as well as healthy and tasty snacks, drinks, and coffee throughout the day. Family Lunch Fridays – AppNexus provides free lunch for the company every Friday.
- Career Development: AppNexus offers a variety of internally-developed learning sessions, customized workshops, and robust professional development programs to help you strengthen your potential, develop new skills, grow your career and make greatness happen at AppNexus.
- An Active Development Community: Participate in company sponsored Hackathons, Innovation days and events.
- Speak, Publish, and Patent: Your groundbreaking work will help enhance the engineering brand at an emerging powerhouse technology company.
http://appnexus.com/open-positions?jvi=oOt7Yfw6
